﻿CREATE TABLE [dbo].[Employee] (
    [EmpID]                     VARCHAR (50)    NOT NULL,
    [EmpName]                   VARCHAR (50)    NULL,
    [EmpNo]                     VARCHAR (50)    NULL,
    [IDCard]                    VARCHAR (40)    NULL,
    [EmpNameEN]                 VARCHAR (50)    NULL,
    [Sex]                       VARCHAR (2)     NULL,
    [Email]                     VARCHAR (50)    NULL,
    [DomainAccount]             VARCHAR (20)    NULL,
    [JobLevel]                  VARCHAR (10)    NULL,
    [JobGrade]                  VARCHAR (10)    NULL,
    [Mobile]                    VARCHAR (50)    NULL,
    [DateBirth]                 VARCHAR (50)    NULL,
    [InGroupDate]               DATE            NULL,
    [InCompanyDate]             DATE            NULL,
    [InDeptDate]                DATE            NULL,
    [InDueDate]                 DATE            NULL,
    [InPositionDate]            DATE            NULL,
    [ContractEndDate]           DATE            NULL,
    [EmpType]                   VARCHAR (20)    NULL,
    [EmpStatus]                 VARCHAR (10)    NULL,
    [WorkAddress]               VARCHAR (20)    NULL,
    [DimissionDate]             DATE            NULL,
    [Nationality]               VARCHAR (10)    NULL,
    [BankName]                  VARCHAR (50)    NULL,
    [BankAccount]               VARCHAR (30)    NULL,
    [SocialSecurityNo]          VARCHAR (50)    NULL,
    [Education]                 VARCHAR (20)    NULL,
    [School]                    VARCHAR (50)    NULL,
    [Major]                     VARCHAR (30)    NULL,
    [NativePlace]               VARCHAR (50)    NULL,
    [RelationName]              VARCHAR (50)    NULL,
    [RelationTel]               VARCHAR (50)    NULL,
    [FlagDeleted]               SMALLINT        NULL,
    [ModDate]                   DATETIME        NULL,
    [ProbationTerm]             SMALLINT        NULL,
    [SyncTime]                  DATETIME        NOT NULL,
    [IsAuditDeptManager]        SMALLINT        NOT NULL,
    [SyncSalaryValidDate]       DATETIME        NOT NULL,
    [CommissionWay]             NCHAR (10)      NULL,
    [JobLevelValidDate]         DATETIME        NULL,
    [IDCard18]                  VARCHAR (50)    NULL,
    [FlagFiveDays]              BIT             NULL,
    [MarriageStatus]            SMALLINT        NULL,
    [CurrentAddress]            VARCHAR (100)   NULL,
    [HomeAddress]               VARCHAR (100)   NULL,
    [FlagOldCompany]            BIT             NULL,
    [Flag2M]                    BIT             NULL,
    [FlagOther]                 BIT             NULL,
    [PersonalBelongTo]          VARCHAR (20)    NULL,
    [AgentCardNumber]           VARCHAR (20)    NULL,
    [AgentCardValidity]         DATETIME        NULL,
    [EmergencyContactRelations] VARCHAR (20)    NULL,
    [FlagIntern]                BIT             NULL,
    [PhysicalExamDate]          DATETIME        NULL,
    [ContractName]              VARCHAR (20)    NULL,
    [ContractType]              VARCHAR (50)    NULL,
    [ContractStartDate]         DATE            NULL,
    [SocialSecurityType]        VARCHAR (20)    NULL,
    [SocialSecurityCost]        DECIMAL (18, 2) NULL,
    [InsurancePayDate]          DATE            NULL,
    [SocialSecuritySubtract]    DECIMAL (18, 2) NULL,
    [FlagMaintainPS]            BIT             NULL,
    [MsgSource]                 NVARCHAR (1000) NULL,
    [SpouseName]                VARCHAR (50)    NULL,
    [SpouseIDCard]              VARCHAR (50)    NULL,
    [PublicFundAccount]         VARCHAR (50)    NULL,
    [BankAccountName]           VARCHAR (50)    NULL,
    [FlagHK]                    BIT             NULL,
    [GuarantorName]             VARCHAR (50)    NULL,
    [GuarantorIDCard]           VARCHAR (50)    NULL,
    [GuarantorTel]              VARCHAR (50)    NULL,
    [GuarantorRelation]         VARCHAR (50)    NULL,
    [PhotoPath]                 VARCHAR (100)   NULL,
    [Remark]                    VARCHAR (500)   NULL,
    [IsHaveBX]                  BIT             NULL,
    [Password]                  VARCHAR (50)    NULL,
    [ShortNo]                   VARCHAR (20)    NULL
);

